At Parseur, we frequently receive inquiries from businesses working out how to combine CSV files (or any spreadsheet) they receive on a recurring basis. Questions are usually along the lines of “How do I combine multiple CSV files into one?” or “How do I automatically merge separate Excel files together?”.
It turns out Parseur can automate this for you in just a few clicks!
Let’s see how to combine CSV and Excel files together in just 3 simple steps.
Many companies still have to work with systems–decades-old legacy systems–that send daily or weekly CSV or Excel file reports. Integrating those spreadsheet reports into a modern data automation workflow can sometimes be a pain, requiring an employee to stay on top of those files and manually consolidate them together. There surely is a better use of your employees’ time than copying and pasting data from one file to a database. Let’s see how we can automate this!
Step 1: Create a Parseur mailbox
The tool we use to combine CSV files is Parseur. Parseur is a powerful mail parser platform that converts emails, attachements and documents into workable data. Parseur is free to use for a reasonably low amount of documents to process, so let’s go ahead and create an account by clicking on the button below:
After registration, Parseur asks you to create your first mailbox.
Enter a name for your mailbox and click Next.
Step 2: forward your CSVs or Excel to Parseur
Now is time to send your files to Parseur. Parseur created an email address for your mailbox. Forward your emails with the CSVs or Excels as attachments to that email address. If you have the files locally on your computer, you can attach them all to a single email. Otherwise, forward the email reports, with the files attached, one by one.
Parseur supports the following Spreadsheet file extensions:
- CSV: .csv,
- Excel: .xls, .xlsx, .xlsm,
- OpenOffice: .ods,
- StarOffice: .sdc,
- Apple Numbers: .numbers
Note: Make sure your files contain a header in the first row with column names that are consistent from one file to the other. Parseur will use the column names in the first row to perform the consolidation.
Then, wait for Parseur to receive your attachments. It usually just takes a couple of seconds. Once received, Parseur will convert your spreadsheet into CSV and will let you know that it received your email and already combined all spreadsheet files automatically!
Go to the Documents section to see your email and converted CSV files.
Click on a CSV document to see the results.
If you have more emails containing CSV files to merge, just send them to your Parseur mailbox as well.
Step 3: Download your merged CSV file
Now, head over the Export section and click on the Download tab to download your combined CSV file as another CSV, as an Excel spreadsheet or as JSON.
Make sure to download the Sheet table so that every row of your CSV appears as a row on your combined file.
Going further: automating everything!
This setup works great but it is not the most efficient. It still involves somebody forwarding emails to Parseur and downloading the data manually. Let’s see how we can remove those manual steps and get a fully automated workflow.
Automate spreadsheet import
If you receive spreadsheets by email on a frequent basis you can automate your file consolidation by setting up a rule to automatically forward those emails to your Parseur mailbox. Head over to this article to learn how to do so: How to automatically forward emails, the definitive guide
Alternatively if you get the CSVs or Excel files deposited on a server, you could write a script that would automatically send the files using our API.
Automate data export
You don’t have to keep downloading your merged data, you can send your CSV data directly where it’s needed in real time!
For example, you can use Parseur’s Google Sheet integration to automatically have your Google Sheet updated when your mailbox processes a new CSV.
To get your merged data automatically updated in Google Sheet:
- Open your Parseur mailbox
- Go to the Export section
- Click on the Google Sheet tab
- Follow the instructions to copy the formula
- Make sure to use the second formula on that page
Send your parsed CSV data directly to your favorite app:
You can also send your data directly to hundreds to applications through our Zapier integration. For example you can have your data directly sent to AirTable, SmartSheet, Excel Online, your favorite CRM or Inventory management app!
- Open you Parseur mailbox
- Go to the Export section
- Click on the Zapier tab
- Search for your application or create a new Zap from scratch
- When creating your zap, make sure to use the “New Table Processed” trigger and select the “Sheet” table
Send your data using a webhook
Finally, if you’re a developer, you can setup a webhook to send your data to go straight where you want it
That’s it! You can now combine CSV files and other spreadsheets in seconds thanks to Parseur.
Don’t hesitate to reach our to us for any question, using the chat box at the bottom right corner of this screen.