How to combine CSV files and spreadsheets together automatically

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.

How to combine CSV files cover image

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 will use to combine CSV files is Parseur. Parseur is a powerful mail parser platform that converts emails, attachments 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:

Create my Free Parseur Account

After registration, Parseur asks you to create your first mailbox.

Enter a name for your mailbox.

Enter a name for your mailbox

Enter a name for your mailbox

Click Next and select Custom emails and attachments

Select emails and attachements

Select emails and attachements

click Next again.

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 ​
Parseur awaits for your first email

Parseur awaits for your first email

Forward or send email(s) containing the CSV files

Forward or send email(s) containing the CSV files

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.

Your CSV files have been processed automatically!

Your CSV files have been processed automatically!

Click on a CSV document to see the results.

On the left, the original CSV content and on the right the same data parsed by Parseur

On the left, the original CSV content and on the right the same data parsed by Parseur

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.

Download your consolidated CSV data in a click

Download your consolidated CSV data in a click

All your CSV data is now combined in one file

All your CSV data is now combined in one file

Step 4: automating everything!

This setup works great but it is not the most efficient. Somebody still has to forward emails to Parseur and download 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 parsed 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.

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 your 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 set up 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 out to us for any question, using the chat box in the bottom right corner of this screen.

Last updated: