🔨 Macro for bulk downloading + renaming images off a database
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
DataStager.vbs %2 encoding errors fixed Apr 8, 2018
README.md Updated README Mar 16, 2018

README.md

Airtable Bulk Downloader And Renamer Overview

AirtableExcelVBA Macro takes a CSV output from Airtable in a 2 column format. Column A is the primaryKey, column B is the image asset name. It downloads all image URLs present, and renames those images based off of column A into a new subfolder.

Sample CSV Download from Airtable

Sample CSV Output after running Macro

Images / Staged Assets created after running Macro

.bat helper file created after running macro

Demonstration

Prerequisites

You'll need to have microsoft excel installed on your computer. Windows OS preferred for running batch file commands.

Installing macro from repo

You can run this macro by going to the "DataStager.VBS" file located in this repo.

  1. Copy the contents of the file
  2. Download and Open your excel file from Airtable if you haven’t (don’t copypaste cells, use the builtin -download CSV button)
  3. Press ALT+F11
  4. Insert code into a module
  5. Run the submodule airtableCleaner()

Installing macro from a excel .xlsm file

Alternatively, you can just download my .xlsm file here

https://www.dropbox.com/s/k1o16u28sj0e0l3/AirtableBulkDownloaderRenamer.xlsm?dl=0

  1. just download my macro enabled workbook
  2. Paste data in the first sheet (exactly the data you’d get from download as CSV from airtable)
  3. Home → view → view macro → airtableCleaner() → run

IMPORTANT NOTES BEFORE RUNNING MACRO!

All of Column A should be unique values. This macro doesn't run otherwise, due to potential naming conflicts

If you want to keep the original file name uploaded to amazonS3, you can easily keep a copy of your original column somewhere else.

You can use this macro for things besides airtable, just format it in the same original input as above.

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Forum Post

Read more at https://community.airtable.com/t/bulk-downloader-and-renamer-using-excel-vba/4913