EmergingTextiles: Live Textile Prices in Excel

Live Textile Prices in Excel

Pull any EmergingTextiles data table into Excel in three clicks. No coding.

ET
Our Website
Click "Copy API Endpoint"
→
X
Excel
Paste into Data > From Web
→
🔄
Refresh Anytime
Right-click for the latest prices
Think of it this way

An API endpoint is like a bookmark that delivers data instead of a web page. Once Excel knows the URL, it can fetch fresh prices on demand, no more visits to the site, no more downloads, no more copy-paste.

2 minutes setup
One-time per data table, never again
Refresh anytime
Right-click the table, latest data appears
Zero install
Power Query is built into Excel already

If you already use Excel for your market analysis, you can replace the copy-paste routine with a live connection to our data. Open your file, click refresh, and the latest prices appear. Here is how.

Three Steps

1
Copy the data URL from our website

Navigate to any price table on EmergingTextiles.com (cotton futures, polyester prices, yarn prices, apparel imports, and so on). Below the table you will see a green button. Click it.

Price table on EmergingTextiles.com with Print Table and Copy API Endpoint buttons

The button copies a URL like the one below to your clipboard. Before pasting it into Excel, replace the yellow-highlighted text with your personal API key (you received it when your subscription was activated).

https://api.emergingtextiles.com/api/csv/New-York_Cotton-Futures/NY-Daily-Prices?api_key=YOUR_API_KEY
2
Paste it into Excel

In Excel, go to the Data tab and click From Web. Paste the URL you just copied, and click OK. Excel will fetch the data and show a preview.

Excel Data From Web dialog with the CSV URL pasted
Paste the URL into Excel's Data > From Web dialog
3
Click Load

Excel shows a preview with the comma delimiter already detected and the columns correctly split. Click Load. The data drops into your worksheet as a clean Excel table, ready for charts, formulas, or pivot tables.

Excel preview dialog with comma delimiter detected and Load button
Excel previews the data with columns correctly split — click Load

From now on, whenever you want the latest data, right-click the table and select Refresh. Your file pulls the newest prices from our server.

Common Questions

How can I get an API key?
An API key comes with a Corporate subscription. Once your subscription is active, your personal key is delivered by our team. If you already have a key but don't have it at hand, email subscriptiondpt@emergingtextiles.info.
Does this work with Google Sheets?
Yes. In Google Sheets use the formula =IMPORTDATA("YOUR_URL"). For advanced options (scheduled refresh, filtering, multi-sheet dashboards), see our full API documentation.
Can I connect more than one table?
Absolutely. Repeat the three steps for each table you want. Each sheet in your Excel file can have its own live connection. Corporate subscribers can also request a custom spreadsheet that bundles all your selected data under a single endpoint.
How often is the data updated?
As often as the underlying source. Daily tables refresh daily, weekly tables weekly, monthly tables monthly. Every click on "Refresh" in Excel pulls the current state of the data.
What if I need help setting this up?
We're happy to walk you through it. Email subscriptiondpt@emergingtextiles.info or use our contact page, and we'll get you up and running quickly.

Next Steps

Understanding Our API → The full technical guide: how APIs work, JSON format, connecting to databases and BI tools. Custom Spreadsheet → Build a single endpoint that bundles only the products and markets you track. Corporate Subscription → Unlock full API access across all of our data tables.