Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I would like to download a CSV file from web page or I can use formatter to go to directly to the URL which seems to change based on the date and then save it as a spreadsheet.

I followed the steps from the below link. 
 


But my file size is around 5-6 MB. So I am getting an error. Any idea how to fix it? I have a deadline to complete, so quick responses will be appreciated.

Hi there @ManDoKOP, thanks for joining the Community here! 😁


Ah, yes ​​​​​​Formatter’s Import CSV File utility is only able to work with files under 150 KB (around 1,000 rows of a 10 column CSV file) at the moment. We’ve got a feature request open for the ability to support larger files so I’ve gone ahead and added your vote to that. This allows us to send you an email notification as soon as it’s resolved.

As a workaround, perhaps you could trying using an app like Split CSV to split the CSV into a series of smaller files that could be processed by Formatter. Then trigger another Zap from the smaller files and add the information into the Google Sheets spreadsheet that way?


Hope that workaround helps to get things up and running in the meantime! 🤞 

Hi there @ManDoKOP, thanks for joining the Community here! 😁


Ah, yes ​​​​​​Formatter’s Import CSV File utility is only able to work with files under 150 KB (around 1,000 rows of a 10 column CSV file) at the moment. We’ve got a feature request open for the ability to support larger files so I’ve gone ahead and added your vote to that. This allows us to send you an email notification as soon as it’s resolved.

As a workaround, perhaps you could trying using an app like Split CSV to split the CSV into a series of smaller files that could be processed by Formatter. Then trigger another Zap from the smaller files and add the information into the Google Sheets spreadsheet that way?


Hope that workaround helps to get things up and running in the meantime! 🤞 

 

Thanks, Can you tell me how to setup the Split CSV action to be used in the below workflow. I have setup and linked my account. But I am not sure how to connect the URL to SplitCSV.
 

 

Hi there @ManDoKOP,

I’m jumping in to see if I can help!

From the workflow you described, it seems like adding the Split CSV action before the Formatter step would be a good recommendation. While I'm not entirely familiar with Split CSV, would it be possible for you to share a screenshot of your current setup for the Split CSV action? That way, I can get a better understanding of how it's configured.

Please keep us posted! 😊

Hi folks,

Just popping by with a quick update to share that the feature request has now been closed. We’ve recently launched a new app that can handle CSV files of up to 1-4MB - Files by Zapier! 😁🎉

It’s currently in Beta but I’d recommend giving it a try to see if it works well for your needs. Do let us know if you run into any questions or issues in using it. In the meantime, happy Zapping! 

Terms & Conditions